EDB's logo

Your Hitchhiker's Guide to the Postgres Documentation

PGconf.de
2022-05-13

Who am I

Image by Anemone123 from Pixabay

Postgres documentation

Image by kerttu from Pixabay

How to begin?

  • Postgres doc is huge
  • 420 tables, but only 3 figures
  • Different formats (html, pdf, man)
Image by Gerd Altmann from Pixabay

What is Postgres doc?

  • Written in PostgreSQL git repo
  • DocBook (xml)
  • built with bison and flex

Clickable versions

Displaying the Postgres doc clickable versions feature
Image by stokpic from Pixabay

Search engine

duckduckgo logo site:https://www.postgresql.org/docs/current/ [keyword here]

Doc page about the doc

PostgreSQL preface
Image by stokpic from Pixabay

Glossary

PostgreSQL glossary
Image by PDPics from Pixabay

Doc how to build the doc

how to build the postgres doc
Image by Faizal Sugi from Pixabay

Jokes!

Installing from source under Windows
Image by Three-shots from Pixabay

Jokes!

Definition of the 'alballs' value for timestamptz
Image by Three-shots from Pixabay

Jokes!

By 1996, it became clear that the name “Postgres95” would not stand the test of time.
Image by Three-shots from Pixabay

Jokes!

Besides the documentation, that is, this book, there are other resources about PostgreSQL:
  • Wiki
  • Web Site
  • Mailing Lists
  • Yourself!
Image by Three-shots from Pixabay

Questionable advises

The installing part of the PostgreSQL documentation https://www.postgresql.org/download/
Image by Pablo Jimeno from Pixabay

Questionable advises

The backup section of the PostgreSQl documentation
Image by Pablo Jimeno from Pixabay

Choose your own adventure: Postgres DBA

Image by Gerd Altmann from Pixabay

What do DBAs do?

  • Installs
  • Upgrades
  • Server setups
  • Configuration
  • Backup/Restore
  • High availability
  • Roles
  • Maintenance
  • Monitoring
  • Troubleshooting
Image by Gerd Altmann from Pixabay
https://dbaday.org/
Image by Gerd Altmann from Pixabay

The DBA's absolute guide

Part 3 of the PostgreSQL documentation
Image by Alexas_Fotos from Pixabay

The DBA's absolute guide: Part III

Image by Alexas_Fotos from Pixabay

The DBA's absolute guide: Part III

Image by Alexas_Fotos from Pixabay

The DBA's absolute guide: Part III

Image by Alexas_Fotos from Pixabay

Other interesting nuggets

Choose your own adventure: Software developer

What do devs need?

  • How to run queries
  • Details about datatypes
  • Details about included functions
  • Details about SQL features
  • How to write stored functions/procedures

The dev's absolute guide: Part II

Image by congerdesign from Pixabay

The dev's absolute guide: Part II

Image by congerdesign from Pixabay

The dev's absolute guide: Part II

Image by congerdesign from Pixabay

Another useful guide: Part V

Image by congerdesign from Pixabay

Cherry on the top

Choose your own adventure: database user

What does a database user need?

  • A good SQL client
  • Help on queries
  • Help on performance
Image par flockine de Pixabay

The user's absolute guide:

  • psql documentation → psql
  • That's all
Image par flockine de Pixabay

So long and thanks for all the fish!

Image by ELG21 from Pixabay